<h1>IT Department Primer</h1>
<b>Installing programs required for a Dev computer</b>
<br>
<br><a href="index.html">Back to Home</a>
<br>
<br><hr><hr><b>Adding Quick Links to Fedora's Top Bar</b>
<br>To add a quick link to the Panel for a program inside the Menu, you can open the Menu, look for the program, for example the Terminal, right click on it, and select 'add this launcher to panel'. 
<br>To add a quick link for a frequently used file or program, open the File Browser and look for the file. Drag the file to the Panel. 
<br>This also works for files on the desktop.
<br>
<br><hr><hr><b>Installing FileZilla</b>
<br>1. Click System>Administration>Add Remove Programs on the Menu bar. 
<br>2. Type Filezilla in the search box and click find or press enter.
<br><hr><img src="filezilla-install.jpg"><hr>
<br>3. An entry for "Filezilla" should appear in the listing after a while. 
<br>4. Check the checkbox beside it and click Apply. It may tell you that additional packages need to be installed. Say Yes to these.
<br>5. A long download will then occur. Maybe 30 minutes or more. If you want, go ahead and install Workaholic (see below) to pass the time. Installing PHP, Apache, Mysql & PhpMyAdmin won't work though, because Yum and Add/Remove Programs use the same system resources.
<br>6. If a "Do you trust this package" dialog box appears, click Yes. You'll have to enter the root password after that.
<br>7. Filezilla will be installed after a while. A link to FileZilla should appear in Applications>Internet.
<br>
<br>To open FileZilla, click Applications>Internet>FileZilla on the Menu Bar. 
<br>Add QuirinoPGO ftp address to bookmarks.
<br>Connect to the QuirinoPGO FTP Server by typing the host and password.
<br>
<br>
<br>
<br><hr><hr><b>Installing Workaholic Alarm Clock</b>
<br>1. Download workaholic.zip from quirinopgo's /www/installers via ftp or visit http://www.quirinopgo.com/installers/workaholic_0.2.0-1.tar.gz
<br>
<br>2. Unzip the workaholic.zip.
<br>
<br>3. Open a terminal and go to the folder created by the unzip operation. You'll have to log in as root to do this. Type 'su' and enter the root password.
(Note: ~ means user directory, your home folder. This is the folder you first appear in when you open a terminal. Typing "cd ~" will send you to your home folder, wherever you are in the directory structure. In the example below, I downloaded the file into my Download folder, which is inside my home folder.) 
Type "make install". This will install Workaholic Alarm Clock in your Linux, and add an application launcher in the Applications>Accessories Menu. If you do it properly, this is what you will see in the terminal:
<br>-------------------
<br>[root@localhost ~]# cd Download
<br>[root@localhost workaholic-0.2.0]# make install
<br>mkdir -p /usr/bin/
<br>mkdir -p /usr/lib/
<br>mkdir -p /usr/lib//workaholic
<br>mkdir -p /usr/share/applications/
<br>mkdir -p /usr/share/man/man1/
<br>mkdir -p /usr/share/workaholic//images/
<br>mkdir -p /usr/share/workaholic//sounds/
<br>mkdir -p /usr/share/pixmaps/
<br>install -m 755 workaholic /usr/bin/
<br>install -m 644 workaholic.py /usr/lib//workaholic/
<br>install -m 644 full_window.py /usr/lib//workaholic/
<br>install -m 644 progress_bar.py /usr/lib//workaholic/
<br>install -m 644 workaholic.desktop /usr/share/applications/
<br>install -m 644 workaholic.png /usr/share/pixmaps/
<br>install -m 644 workaholic.1 /usr/share/man/man1/
<br>install -m 644 images/*.* /usr/share/workaholic//images/
<br>install -m 644 sounds/*.* /usr/share/workaholic//sounds/
<br>install -m 644 AUTHORS /usr/share/workaholic/
<br>install -m 644 COPYING /usr/share/workaholic/
<br>[root@localhost workaholic-0.2.0]# 
<br>-------------------
<br>
<br><hr><hr><b>Installing PHP, Apache, Mysql & PhpMyAdmin</b>
<br>Thanks to 
<br>Dan Stoner of 
<br>Office of Museum Technology
<br>Florida Museum of Natural History
<br>Florida University
<br>
<br>This web page was originally found by googling "Fedora PHP Apache Mysql". I republish it <a href="installing_apache_php_mysql.html">here</a> with all due respect and gratitude.
<br>
<br>Or just follow these instructions (derived from the above mentioned web page): 
<br>
<br>1. Open a terminal
<br>
<br>2. Type 'su' at the terminal and enter the root password to log in as root.
<br>
<br>3. Type 
<br>-----------------------------
<br>yum -y install httpd php mysql mysql-server php-mysql php-xml phpmyadmin svn
<br>-----------------------------
<br>and press enter. This will automaticall install all these packages without user intervention, unless an error occurs. If an "I ran out of mirrors" error occurs, try installing it at a different time of the day, especially if you're doing this at night. Presumably, more servers will be accessible during the day. Some people shut down their servers at night, and maybe on weekends, to save electricity. 
<br>
<br>4. Enter these commands except for those in []'s
<br>------------------------------
<br>/sbin/chkconfig httpd on
<br>/sbin/chkconfig --add mysqld         
<br>  [this is not required with FC4 and above]
<br>/sbin/chkconfig mysqld on
<br>
<br>/sbin/service httpd start
<br>/sbin/service mysqld start
<br>
<br>mysql -u root -p
<br>  [This will ask for the password and log you into the mysql program. Inside the mysql program type or simply paste the following lines:]
<br>
<br>DROP DATABASE test;                            
<br>DELETE FROM mysql.user WHERE user = '';        
<br>FLUSH PRIVILEGES;
<br>------------------------------
<br>
<br>5. Open a browser window and type "http://localhost" or simply "localhost" in the address. You should not see an error message. 
<br>
<br><b>Your local web server is now online.</b> /var/www/html is the home directory for your local web server. This means that anything you put in here will be accessible to the outside world. To test this, create a new file index.php, place it in /www/html, paste the following lines into it:
<br>------------------------------
<br>&lt;?php phpinfo();?&gt;
<br>------------------------------
<br>If you're doing this for the first time, you'll probably get a permission error. To fix this, login as root if you haven't, and enter the following lines:
<br>-----------
<br>chown [username] .
<br>-----------
<br>This will set the ownership of the html folder to you. You can now create files and folders in it. Please try again.
<br>Now open your browser to http://localhost and you'll see that the home page has changed.
<br>* instead of /var/www/html, WAMP uses c:/wamp/www, or [wherever you installed it]\www.
<br>* to change the ownership of all files and folders inside html, type 'chown [username] . -R' instead. '-R' means 'recursive'.
<br>* '.' (period) means 'current directory'. '..' means parent directory. You could just as well type 'chown [username] /var/www/html' in the example above.
<br>
<br>6. To test PHPMyAdmin, open a browser and type http://localhost/phpmyadmin. A dialog box will appear asking for the password. Type 'root' as the username, and the mysql password. 
<br>* if you installed PHPMyAdmin separately, you have to restart Apache by typing the following to make it accessible. Type:
<br>-----------
<br>service httpd restart
<br>-----------
<br>
<br><hr><hr><b>Disabling SELinux</b>
<br>SELinux is a program that enforces security options on Linux. On a server, this really shouldn't be disabled, but on a software developer's computer, you'll want all the power you can get. To disable SELinux, 
<br>1. Open a terminal and log in as root. To do this, type 'su' and enter the root password.
<br>
<br>2. Type 'gedit /etc/selinux/config'. A text editor window will appear. 
<br>
<br>3. Change where it says 'SELINUX=enforcing' to 'SELINUX=disabled'. 
<br>
<br>4. Save the document and exit.
<br>
<br>5. Restart your computer.
<br>
<br><hr><hr><b>Installing Symfony programs</b>
<br>1. Download the Symfony program zip (example, http://www.quirinopgo.com/qlife.zip) 
<br>
<br>2. Open the File Browser and use it to move the zip file to /var/www/html, and extract it there.
<br>
<br>3. Open a Terminal, go inside the newly created folder 
<br>--------------
<br>cd /var/www/html/qlife
<br>--------------
<br>and type the following:
<br>--------------
<br>./rebuild
<br>--------------
<br>This will create the necessary database tables inside mysql. This will only work if the mysql username and password specified inside the symfony program matches the username and password of your mysql installation. To see if this is successful, open http://localhost/phpmyadmin in your browser, and look for a new database with a name similar to your program's name. (Careful - if the database already exists, for example, with a program that is already in use, the old database will be deleted and a new one created in its place. All the previous data will be lost.)
<br>
<br>4. In the terminal, type 
<br>--------------
<br>gedit /etc/httpd/conf/httpd.conf
<br>--------------
<br>This will open a text editor. Look for the line where it says 'rewrite'. It should not have a '#' (comment) before it. If it does, please remove it. Symfony needs this module loaded to make your links work properly.
<br>
<br>5. Scroll down to the bottom of the file and paste the following:
<br>--------------
<br>listen&nbsp;82
<br>&lt;VirtualHost&nbsp;localhost:82&gt;
<br>&nbsp;&nbsp;DocumentRoot&nbsp;"/var/www/html/qlife/web"
<br>&nbsp;&nbsp;DirectoryIndex&nbsp;index.php
<br>&nbsp;&nbsp;&lt;Directory&nbsp;"/var/www/html/qlife/web"&gt;
<br>&nbsp;&nbsp;&nbsp;&nbsp;AllowOverride&nbsp;All
<br>&nbsp;&nbsp;&nbsp;&nbsp;Allow&nbsp;from&nbsp;All
<br>&nbsp;&nbsp;&lt;/Directory&gt;
<br>&nbsp;&nbsp;Alias&nbsp;/sf&nbsp;/var/www/html/qlife/web/sf
<br>&nbsp;&nbsp;&lt;Directory&nbsp;"/var/www/html/qlife/web/sf"&gt;
<br>&nbsp;&nbsp;&nbsp;&nbsp;AllowOverride&nbsp;All
<br>&nbsp;&nbsp;&nbsp;&nbsp;Allow&nbsp;from&nbsp;All
<br>&nbsp;&nbsp;&lt;/Directory&gt;
<br>&lt;/VirtualHost&gt;
<br>--------------
<br>where 'qlife' is the folder name, and 82 is the port you want it to open to. 
<br>You can set as many of these as you want, for as many programs as you have ports to set them to. You cannot use certain ports, however. Generally you can use ports from 80 and above, but 87 is a reserved port. 
<br>
<br>6. Save the file and exit the text editor. Be careful not to touch anything else. 
<br>
<br>7. Restart httpd by typing
<br>--------------
<br>service httpd restart
<br>--------------
<br>in the terminal. 
<br>
<br>You can now open your program in the browser by going to httpd://localhost:82. 
<br><hr><hr><b>Installing Symfony programs from GoogleCode</b>
<br>
<br>Open a terminal, go to www/html, and enter 
<br>--------------------------
<br>svn checkout https://quirinoaccountable.googlecode.com/svn/trunk/ accountable
<br>--------------------------
<br>
<br>This will copy the files for the program QuirinoAccountable in the folder accountable. Follow the steps in the previous tutorial from step 3 onwards.
<br>You can install other programs by substituting 'quirinoaccountable' for one of the following:
<br>quirinoacct - Accounting Program
<br>quirinocomm - Communications Tracking Program for PGSO (Also useful as all purpose documentation program)
<br>quirinoforecast - Budget Forecast Program
<br>quirinohr - Human Resource Program
<br>quirinoit - IT Department Tutorials
<br>quirinomail2 - Mail Room Program
<br>quirinoprojecttracker - Construction Project Tracker
<br>quirinovehicle - Vehicle Tax Program for Treasury Dept
<br>quirinolife - Quirino Life Program
<br>quirinosurvey 
<br>
<br><hr><hr><b>Special Considerations for Installing Symfony programs from GoogleCode</b>
<br>For compatibility with the FastDomain webhosting service, some / most of these programs are configured to run with database user 'planetco_root' and database names with the prefix planetco_. Feel free to edit these to match your needs. For the sake of convenience, you can also create the user planetco_root in your own local Mysql.
<br>
<br>To save time / space creating the SVN Repositories, some project repos have the folder lib/symfony ommitted. This is because this folder contains lots of files and takes much time to upload and download, yet are not subject to change. If an error occurs during ./rebuild, see if this folder is present. If not, simply download it from the quirinoaccountable repository. (You can checkout QuirinoAccountable and simply copy the lib/symfony folder. It is also available as a zip file in QuirinoSurvey) These projects include quirinoforecast & quirinohr.
<br>
<br>To create a non-development copy of a program from GoogleCode, use 'svn export' instead of 'svn checkout'. This will omit the .svn folders from the local copy created.
<br>
<br>Some of the programs will require a username and password when checking out, exporting and committing. The username is jaspertomas. The password is jB5rE8AV4za2. If asked for the root password, simply press enter to be promped the username. 
<br>
<br>Quirinoaccountable:  
<br> - In the terminal, before running ./rebuild, go to quirinoaccountable/config and make a copy of 'database.yml.sample'. rename it to 'database.yml'. 
<br>
<br>Quirinohr
<br> - an SQL dump of the employees data (as of feb 2010 maybe) exists in the /doc/employees.sql file. Simply paste the contents of this file into phpmyadmin, if desired.
<br>
<br>
<br>
<br>
<br><hr><hr><b>Special Considerations for Using Symfony Programs</b>
<br>Putting more than one program in the same server and using them one after the other creates a small problem. For instance, I logged into quirinocomm, and then without logging out, I open quirinoforecast and try to log in. An error page will result. This can be resolved by simply pressing the Back button on your browser toolbar to return to the login page, and trying again. 
<br>
<br>
<br>
<br>
<br><br><hr><hr><b></b>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>

